Duplicate Rates
This function allows rates to be duplicated – most commonly from one Date Range/Price Code to another Price Code.
In this example, the service only has a Nett Rates Price Code for the date periods 03 January 2025 to 31 March 2025. This is in fact the Nett rate price code which has no markup at the database level. The task is to add price codes T1 (which has a 12.50% Markup).
Duplicating Rates
-
On the Duplicate Rates screen the
Filter Tab will open, enter a date range for Rates Based On and Based To, select required filter fields to narrow search results.
-
Select the
Analysis Tab, expand the Analysis Fields to select required Analysis Code checkboxes.
- Check the completed screens.
- View returned results either:
- Click on the
Results Tab, or
- Select the
Search button.
-
Click
Save to keep the changes.
- A further Duplicate Rates screen will show, fields can be selected controlling how the rate is to be duplicated.
- Make the required amendments, refer to Duplicate Rates Second Screen for information of fields.
-
Click
Save to keep the changes.
About Duplicate Rates Filter Options
Product options can be updated in bulk by selecting the required filters. Below are the filter selections available when using Duplicate Rates in Rate Maintenance.
Filter Tab
Rates
This section is for selecting specific rates within the services select in
The following selection fields are available:
Based On & Based To
A From Date/To Date selection. The date ranges of the rates to be duplicated.
As an example, rate period from 03 January 2025 to 31 March 2025 requires the nett rate to be duplicated, with the intention of creating a T1 price code with a 12.5% mark up, the Based On date would be the first rate date, and the Based To would be the last rate date. (These field can not be left blank)
Price Code
Selected price code.
Cost Currency
Rates with the selected Cost Currency.
NOTE: Leave blank to select all Cost Currencies
Sell Currency
Rates with the selected Sell Currency.
NOTE: Leave blank to select all Sell Currencies
Product
This section is for selecting the services that are going to have rate maintenance performed.
With the exception of the Service Code (which is a Multi List Select)
Selection Fields Available | All selections are From/To (Alphabetically) |
---|---|
Location Code (From/To) | To select locations, users can use the dropdown selection, providing a full list of locations, or manual entry of the three character location code can be used. Using this field will filter all products/services that are from/to the specified location. |
Supplier Code (From/To) |
Selection of Suppliers can be done by using the dropdown selection, typing the Supplier Code, or by searching for the Supplier using the search button. |
(Option) Code (From/To) | A specific option code for the product option. |
Service
All Service types or selected Service types.
Rate Status
All or selected Rate Statuses.
Analysis Tab
The 6 Product Analysis fields and 6 Supplier Analysis fields are grouped in this section. By default, all analysis codes within each heading are checked. To select specific analysis codes, click on the + next to the analysis code name and select/unselect codes as required.
Duplicate Rates Second Selection Screen
Duplicate Rates, has a second selection screen which controlls how the duplicated rate is to be applied and settings include currencies, cost/sell changes and rounding, price codes, exchange rates and taxes, and how the mark up is to be set. The description of all fields in this screen are given below.
New Price Code
Select the New Price Code (the one being copied to) from the drop down list.
Cost Currency
Choices are to retain existing Currency or change to. If Change To is checked, the new cost currency can be selected from the drop down.
FIT Cost
Change By
This field refers to the FIT Cost Rate field in the Service Rates screen. A numeric value can be entered into this field
%
The two choices available from the drop-down indicate whether the value in the Change FIT Cost field is a percentage (%) or a currency amount (Flat Rate). The combination of these two fields will adjust the values of the FIT Cost column in the Service Rates screen.
Round To Nearest
There are 6 choices available from the drop down. They are: None-No rounding, One Tenth-Nearest 0.10, One Half-Nearest 0.50, One-Nearest 1.00, Five-Nearest 5.00 or 10-Nearest 10.00. Rounding is on the basis of up to .5 round down; over .5 round up.
Groups Cost
Change By
This field refers to the Group Cost Rate field in the Service Rates screen and can have a numeric value entered.
%
The two choices available from this drop-down, indicates whether the value in the Change Groups Cost field is a percentage (%) or a currency amount (Flat Rate). The combination of these two fields will adjust the values in the Group column in the Service Rates screen.
Round To Nearest
There are 6 choices available from the drop down. They are: None-No rounding, One Tenth-Nearest 0.10, One Half-Nearest 0.50, One-Nearest 1.00, Five-Nearest 5.00 or 10-Nearest 10.00. Rounding is on the basis of up to .5 round down; over .5 round up.
Sell Currency
Choices are to Retain Existing Currency or Change To. If "Change To" is checked, the new cost currency can be selected from the drop down.
FIT Sell
Change By
This field refers to the FIT sell rate and can have a numeric value entered.
%
This drop-down determines how the value in Change FIT Sell value will be applied:
Percentage |
The value will be applied as percentage to existing FIT Sell Rates. |
Mark Up % |
The value will be applied as a markup % to the FIT Costs |
Flat Rate |
The value will be applied as a flat rate (currency amount) |
Round To Nearest
There are 6 choices available from the drop down. They are: None-No rounding, One Tenth-Nearest 0.10, One Half-Nearest 0.50, One-Nearest 1.00, Five-Nearest 5.00 or 10-Nearest 10.00. Rounding is on the basis of up to .5 round down; over .5 round up.
Groups Sell
Change By
This field refers to the Group Sell rate and can have a numeric value entered.
%
This drop-down determines how the value in Change Groups Sell value will be applied:
Percentage |
The value will be applied as percentage to existing Group Sell Rates. |
Mark up % |
The value will be applied as a markup % to the Group Costs |
Flat Rate |
The value will be applied as a flat rate (currency amount) |
Round To Nearest
There are 6 choices available from the drop down. They are: None-No rounding, One Tenth-Nearest 0.10, One Half-Nearest 0.50, One-Nearest 1.00, Five-Nearest 5.00 or 10-Nearest 10.00. Rounding is on the basis of up to .5 round down; over .5 round up.
Exchange Rate
If the buy and sell currencies in the service are different, then the exchange rate used to calculate the rate can be updated here (see Apply Different Buy/Sell Currencies).
Rate Status
If retain existing is selected no further selections are required for this field, the existing rate status of the price code/date range will be retained. However if 'Change To' is selected there are 5 choices from the drop-down enabling the rate status to be changed to:
Closed |
The Rate Status will be changed to Closed |
Confirmed |
The Rate Status will be changed to Confirmed |
Manual |
The Rate Status will be changed to Manual |
Provisional |
The Rate Status will be changed to Provisional |
Terminal |
The Rate Status will be changed to Terminal |
Options
Set Apply Markup
This choice can update the ‘Sell With Markup’ flag. The options are Retain Existing Value, Yes (will set the Sell With Markup Flag ‘On’), or No (will set the ‘Sell With Markup Flag ‘Off’)
Update Pax Breaks
Checking this box ensures that all rates that are against any existing Pax Breaks are also updated.
Overwrite Existing Rates
If rates already exist for some of the Service Option and Rate Selections made, then the existing rates will not be overwritten unless this box is checked. If the box is not checked and the system detects existing rates, the processing will not continue until the box is checked.
Always Round Up
When checked, any rounding will always be up.
Attach Taxes
This field gives the choice of either retaining any existing taxes that have already been attached, have no taxes attached (None) or Attach Taxes selected.
Taxes
When the ‘Selected’ radio button (in Attach Taxes above) is checked, the list of available taxes displays and the applicable tax(es) can be checked.